package com.apes.fa.respository;

import com.apes.fa.model.FaAssetsTransferOutItem;
import com.apes.framework.jpa.repository.CustomRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface FaAssetsTransferOutItemRepository extends CustomRepository<FaAssetsTransferOutItem,String> {

    @Query(value = "" +
            " SELECT " +
            " * " +
            " FROM " +
            " fa_assets_transfer_out_item f" +
            " WHERE " +
            " f.fa_card_id = :id" +
            " ORDER BY f.acceptance_date ASC"
            ,nativeQuery = true)
    List<FaAssetsTransferOutItem> findCard(String id);

}
